TG: sql_for_qa/88

SQL для тестировщика

Дана таблица работников с назаванием "employees" и колонками "employee_id", "first_name", "last_name", "hire_date", "salary". Какой из следующих SQL запросов выведет топ-5 самых высокооплачиваемых работников?

Anonymous Quiz

SELECT * FROM employees WHERE salary = (SELECT MAX(salary) FROM employees) LIMIT 5;

SELECT first_name, last_name, MAX(salary) FROM employees GROUP BY first_name, last_name LIMIT 5;

SELECT * FROM employees ORDER BY salary DESC LIMIT 5;

588 answered

www.tg-me.com/de/SQL для тестировщика/com.sql_for_qa/88

2.9K viewsApr 30, 2023 at 09:29

tg-me.com/sql_for_qa/88

Create: 2023-04-30
Last Update: 2025-07-02 13:50:03

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/88

SQL для тестировщика Telegram | DID YOU KNOW?

The global forecast for the Asian markets is murky following recent volatility, with crude oil prices providing support in what has been an otherwise tough month. The European markets were down and the U.S. bourses were mixed and flat and the Asian markets figure to split the difference.The TSE finished modestly lower on Friday following losses from the financial shares and property stocks.For the day, the index sank 15.09 points or 0.49 percent to finish at 3,061.35 after trading between 3,057.84 and 3,089.78. Volume was 1.39 billion shares worth 1.30 billion Singapore dollars. There were 285 decliners and 184 gainers.